<?php
    // Created By : Julian Ponce
    // B.S. Computer Science - De La Salle Canlubang
    // September 12, 2011

// Start - Checker for those users who will just go to the page by typing directly in the url.
if ($_POST) { 
    // INCLUDES CONFIGURATION VARIABLES FOR DATABASE ACCESS
    include('../includes/siteConfig.php');

    // CONNECT TO DATABASE
    $connect = mysql_connect($hostName,$rootName,$dBasePassword) or die ('Unable to connect!');
    mysql_select_db($dBaseName) or die ('Unable to select database!');
    
    // GET VARIABLES VIA POST METHOD
    $username = $_POST['username'];
    
    
    
        $query = 
            "
              SELECT *
              FROM Account
              WHERE username = '$username'

            ";
  

    $result = mysql_query($query) or die ('Error in query: $query. ' . mysql_error());
    
    // SAVE QUERY RESULTS TO AN ARRAY > $row   
    if (mysql_num_rows($result) > 0) {
        echo json_encode(0);
    }

    else {
        echo json_encode(1);
    }
    

 
    
//    mysql_free_result($result);
    mysql_close($connect);
}   // End - Checker for those users who will just go to the page by typing directly in the url.
else {
 echo "You are not authorized to view this page. This incident will be reported immediately.";
}
?>
